package edu.iwyf.pms.dao;

import edu.iwyf.pms.entity.SysRole;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @Author 王永飞
 * 2021/12/23 8:24
 */
public interface SysRoleDao {

    @Select("select r.id,name,description from sys_role r join sys_user_role ur on r.id = ur.roleid where userid=#{id}")
    List<SysRole> selectedByUserId(@Param("id")int id);
}
